# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月18日
"""
import openpyxl

myBook = openpyxl.load_workbook('员工表.xlsx')
mySheet=myBook.active

myValues=list(mySheet.values)
myNewBook=openpyxl.Workbook()
myNewSheet=myNewBook.active
myNewSheet.title='员工表'
myNewSheet.append(['工号','部门','姓名','最高学历','专业','出生年份'])
for myRow in myValues[1:]:
	myList=[]
	myList+=[myRow[0]]
	myList+=[myRow[1][:3]]
	myList+=[myRow[1][4:]]
	myList+=myRow[2:]
	myNewSheet.append(myList)
myNewBook.save('结果表-员工表.xlsx')